Profiling week1

Dataset statistics

Number of variables	16
Number of observations	906292
Missing cells	157616
Missing cells (%)	1.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	110.6 MiB
Average record size in memory	128.0 B

Variable types

Numeric	12
Categorical	4

Alerts

`time` has a high cardinality: 37662 distinct values	High cardinality
`gameId` is highly correlated with `team`	High correlation
`frameId` is highly correlated with `s` and 1 other fields	High correlation
`s` is highly correlated with `dis`	High correlation
`a` is highly correlated with `s`	High correlation
`dis` is highly correlated with `s`	High correlation
`team` is highly correlated with `gameId`	High correlation
`nflId` has 39404 (4.3%) missing values	Missing
`jerseyNumber` has 39404 (4.3%) missing values	Missing
`o` has 39404 (4.3%) missing values	Missing
`dir` has 39404 (4.3%) missing values	Missing
`s` has 60334 (6.7%) zeros	Zeros
`a` has 56293 (6.2%) zeros	Zeros
`dis` has 60300 (6.7%) zeros	Zeros

Reproduction

Analysis started	2022-11-02 15:02:04.237892
Analysis finished	2022-11-02 15:03:26.588502
Duration	1 minute and 22.35 seconds
Software version	pandas-profiling v3.4.0
Download configuration	config.json

gameId
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	13
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2021102393

Minimum	2021102100
Maximum	2021102500
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	2021102100
5-th percentile	2021102100
Q1	2021102402
median	2021102405
Q3	2021102408
95-th percentile	2021102500
Maximum	2021102500
Range	400
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	80.41104086
Coefficient of variation (CV)	3.978573334 × 10^-8
Kurtosis	8.395453966
Mean	2021102393
Median Absolute Deviation (MAD)	3
Skewness	-2.871199535
Sum	1.83170893 × 10¹⁵
Variance	6465.935492
Monotonicity	Increasing

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
2021102400	90735	10.0%
2021102405	80178	8.8%
2021102401	77970	8.6%
2021102404	73163	8.1%
2021102500	71323	7.9%
2021102403	71277	7.9%
2021102402	71047	7.8%
2021102406	66516	7.3%
2021102407	64492	7.1%
2021102409	64354	7.1%
Other values (3)	175237	19.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2021102100	57431	6.3%
2021102400	90735	10.0%
2021102401	77970	8.6%
2021102402	71047	7.8%
2021102403	71277	7.9%
2021102404	73163	8.1%
2021102405	80178	8.8%
2021102406	66516	7.3%
2021102407	64492	7.1%
2021102408	63250	7.0%

Value	Count	Frequency (%)
2021102500	71323	7.9%
2021102410	54556	6.0%
2021102409	64354	7.1%
2021102408	63250	7.0%
2021102407	64492	7.1%
2021102406	66516	7.3%
2021102405	80178	8.8%
2021102404	73163	8.1%
2021102403	71277	7.9%
2021102402	71047	7.8%

playId
Real number (ℝ_≥0)

Distinct	832
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2176.401355

Minimum	55
Maximum	4255
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	55
5-th percentile	319
Q1	1170
median	2227
Q3	3233
95-th percentile	3904
Maximum	4255
Range	4200
Interquartile range (IQR)	2063

Descriptive statistics

Standard deviation	1169.259945
Coefficient of variation (CV)	0.5372446318
Kurtosis	-1.211676161
Mean	2176.401355
Median Absolute Deviation (MAD)	1031
Skewness	-0.09884512439
Sum	1972455137
Variance	1367168.819
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2293	4646	0.5%
2855	4025	0.4%
3244	3427	0.4%
385	3220	0.4%
3744	3151	0.3%
1177	3059	0.3%
1415	2921	0.3%
3971	2875	0.3%
2035	2852	0.3%
3392	2852	0.3%
Other values (822)	873264	96.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
55	736	0.1%
56	2346	0.3%
61	736	0.1%
62	1035	0.1%
64	897	0.1%
75	989	0.1%
78	759	0.1%
85	874	0.1%
94	989	0.1%
96	805	0.1%

Value	Count	Frequency (%)
4255	782	0.1%
4226	966	0.1%
4222	943	0.1%
4201	920	0.1%
4198	851	0.1%
4180	966	0.1%
4177	989	0.1%
4123	989	0.1%
4101	1311	0.1%
4077	713	0.1%

nflId
Real number (ℝ_≥0)

MISSING

Distinct	974
Distinct (%)	0.1%
Missing	39404
Missing (%)	4.3%
Infinite	0
Infinite (%)	0.0%
Mean	46021.23712

Minimum	25511
Maximum	54006
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	25511
5-th percentile	38557
Q1	42765
median	46094
Q3	48455
95-th percentile	53505
Maximum	54006
Range	28495
Interquartile range (IQR)	5690

Descriptive statistics

Standard deviation	4982.508709
Coefficient of variation (CV)	0.1082654231
Kurtosis	0.005408309907
Mean	46021.23712
Median Absolute Deviation (MAD)	3195
Skewness	-0.2144367005
Sum	3.989525821 × 10¹⁰
Variance	24825393.04
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
43367	2516	0.3%
39146	2516	0.3%
45330	2516	0.3%
46152	2516	0.3%
53655	2516	0.3%
53492	2516	0.3%
46221	2516	0.3%
47971	2516	0.3%
47906	2510	0.3%
41222	2510	0.3%
Other values (964)	841740	92.9%
(Missing)	39404	4.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
25511	1072	0.1%
29550	1639	0.2%
29851	1405	0.2%
30842	359	< 0.1%
30869	1565	0.2%
33084	1539	0.2%
33107	1297	0.1%
33130	192	< 0.1%
33131	1167	0.1%
33138	643	0.1%

Value	Count	Frequency (%)
54006	75	< 0.1%
53959	225	< 0.1%
53957	1255	0.1%
53953	1565	0.2%
53946	357	< 0.1%
53933	721	0.1%
53910	465	0.1%
53900	1018	0.1%
53876	365	< 0.1%
53740	565	0.1%

frameId
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	175
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.2447721

Minimum	1
Maximum	175
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	11
median	22
Q3	33
95-th percentile	55
Maximum	175
Range	174
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	17.4079648
Coefficient of variation (CV)	0.7180090094
Kurtosis	6.558688704
Mean	24.2447721
Median Absolute Deviation (MAD)	11
Skewness	1.655587672
Sum	21972843
Variance	303.0372386
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	21091	2.3%
14	21091	2.3%
24	21091	2.3%
23	21091	2.3%
2	21091	2.3%
21	21091	2.3%
20	21091	2.3%
19	21091	2.3%
18	21091	2.3%
17	21091	2.3%
Other values (165)	695382	76.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	21091	2.3%
2	21091	2.3%
3	21091	2.3%
4	21091	2.3%
5	21091	2.3%
6	21091	2.3%
7	21091	2.3%
8	21091	2.3%
9	21091	2.3%
10	21091	2.3%

Value	Count	Frequency (%)
175	23	< 0.1%
174	23	< 0.1%
173	23	< 0.1%
172	23	< 0.1%
171	23	< 0.1%
170	23	< 0.1%
169	23	< 0.1%
168	23	< 0.1%
167	23	< 0.1%
166	23	< 0.1%

time
Categorical

HIGH CARDINALITY

Distinct	37662
Distinct (%)	4.2%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

2021-10-24T17:42:21.300	69
2021-10-24T17:42:22.400	69
2021-10-24T17:42:22.600	69
2021-10-24T17:42:22.700	69
2021-10-24T17:42:22.800	69
Other values (37657)	905947

Length

Max length	23
Median length	23
Mean length	23
Min length	23

Characters and Unicode

Total characters	20844716
Distinct characters	14
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	2021-10-22T00:23:17.300
2nd row	2021-10-22T00:23:17.400
3rd row	2021-10-22T00:23:17.500
4th row	2021-10-22T00:23:17.600
5th row	2021-10-22T00:23:17.700

Common Values

Value	Count	Frequency (%)
2021-10-24T17:42:21.300	69	< 0.1%
2021-10-24T17:42:22.400	69	< 0.1%
2021-10-24T17:42:22.600	69	< 0.1%
2021-10-24T17:42:22.700	69	< 0.1%
2021-10-24T17:42:22.800	69	< 0.1%
2021-10-24T17:42:22.900	69	< 0.1%
2021-10-24T17:42:23.000	69	< 0.1%
2021-10-24T17:42:23.100	69	< 0.1%
2021-10-24T17:42:23.200	69	< 0.1%
2021-10-24T17:42:23.300	69	< 0.1%
Other values (37652)	905602	99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2021-10-24t17:42:21.300	69	< 0.1%
2021-10-24t17:42:21.000	69	< 0.1%
2021-10-24t20:07:02.100	69	< 0.1%
2021-10-24t19:27:43.800	69	< 0.1%
2021-10-24t17:42:22.500	69	< 0.1%
2021-10-24t18:20:59.300	69	< 0.1%
2021-10-24t17:42:22.300	69	< 0.1%
2021-10-24t18:20:59.000	69	< 0.1%
2021-10-24t17:42:22.200	69	< 0.1%
2021-10-24t18:20:58.900	69	< 0.1%
Other values (37652)	905602	99.9%

Most occurring characters

Value	Count	Frequency (%)
0	4496869	21.6%
2	3803532	18.2%
1	2958652	14.2%
-	1812584	8.7%
:	1812584	8.7%
4	1305503	6.3%
T	906292	4.3%
.	906292	4.3%
5	622587	3.0%
3	601658	2.9%
Other values (4)	1618163	7.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	15406964	73.9%
Other Punctuation	2718876	13.0%
Dash Punctuation	1812584	8.7%
Uppercase Letter	906292	4.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	4496869	29.2%
2	3803532	24.7%
1	2958652	19.2%
4	1305503	8.5%
5	622587	4.0%
3	601658	3.9%
9	453997	2.9%
7	413147	2.7%
8	395255	2.6%
6	355764	2.3%

Other Punctuation

Value	Count	Frequency (%)
:	1812584	66.7%
.	906292	33.3%

Dash Punctuation

Value	Count	Frequency (%)
-	1812584	100.0%

Uppercase Letter

Value	Count	Frequency (%)
T	906292	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	19938424	95.7%
Latin	906292	4.3%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	4496869	22.6%
2	3803532	19.1%
1	2958652	14.8%
-	1812584	9.1%
:	1812584	9.1%
4	1305503	6.5%
.	906292	4.5%
5	622587	3.1%
3	601658	3.0%
9	453997	2.3%
Other values (3)	1164166	5.8%

Latin

Value	Count	Frequency (%)
T	906292	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	20844716	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	4496869	21.6%
2	3803532	18.2%
1	2958652	14.2%
-	1812584	8.7%
:	1812584	8.7%
4	1305503	6.3%
T	906292	4.3%
.	906292	4.3%
5	622587	3.0%
3	601658	2.9%
Other values (4)	1618163	7.8%

jerseyNumber
Real number (ℝ_≥0)

MISSING

Distinct	99
Distinct (%)	< 0.1%
Missing	39404
Missing (%)	4.3%
Infinite	0
Infinite (%)	0.0%
Mean	49.35768173

Minimum	1
Maximum	99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	22
median	51
Q3	75
95-th percentile	95
Maximum	99
Range	98
Interquartile range (IQR)	53

Descriptive statistics

Standard deviation	29.80968417
Coefficient of variation (CV)	0.603952275
Kurtosis	-1.321476716
Mean	49.35768173
Median Absolute Deviation (MAD)	27
Skewness	0.03295354894
Sum	42787582
Variance	888.6172703
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
21	19172	2.1%
24	17369	1.9%
2	17149	1.9%
22	15586	1.7%
51	15008	1.7%
23	14680	1.6%
72	14554	1.6%
1	14406	1.6%
29	13786	1.5%
25	13630	1.5%
Other values (89)	711548	78.5%
(Missing)	39404	4.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	14406	1.6%
2	17149	1.9%
3	2871	0.3%
4	10684	1.2%
5	8293	0.9%
6	6249	0.7%
7	3149	0.3%
8	9373	1.0%
9	7514	0.8%
10	13284	1.5%

Value	Count	Frequency (%)
99	11337	1.3%
98	11084	1.2%
97	12753	1.4%
96	8001	0.9%
95	7228	0.8%
94	11312	1.2%
93	7789	0.9%
92	8563	0.9%
91	13350	1.5%
90	12874	1.4%

team
Categorical

HIGH CORRELATION

Distinct	27
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

BAL	43395
CIN	43395
football	39404
TEN	38346
KC	38346
Other values (22)	703406

Length

Max length	8
Median length	3
Mean length	2.926798427
Min length	2

Characters and Unicode

Total characters	2652534
Distinct characters	29
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	DEN
2nd row	DEN
3rd row	DEN
4th row	DEN
5th row	DEN

Common Values

Value	Count	Frequency (%)
BAL	43395	4.8%
CIN	43395	4.8%
football	39404	4.3%
TEN	38346	4.2%
KC	38346	4.2%
GB	37290	4.1%
WAS	37290	4.1%
NYG	34991	3.9%
CAR	34991	3.9%
SEA	34111	3.8%
Other values (17)	524733	57.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
bal	43395	4.8%
cin	43395	4.8%
football	39404	4.3%
ten	38346	4.2%
kc	38346	4.2%
gb	37290	4.1%
was	37290	4.1%
nyg	34991	3.9%
car	34991	3.9%
sea	34111	3.8%
Other values (17)	524733	57.9%

Most occurring characters

Value	Count	Frequency (%)
A	279807	10.5%
N	272580	10.3%
I	195338	7.4%
E	193292	7.3%
C	174977	6.6%
L	167497	6.3%
T	134915	5.1%
B	111463	4.2%
S	97493	3.7%
H	91872	3.5%
Other values (19)	933300	35.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2337302	88.1%
Lowercase Letter	315232	11.9%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	279807	12.0%
N	272580	11.7%
I	195338	8.4%
E	193292	8.3%
C	174977	7.5%
L	167497	7.2%
T	134915	5.8%
B	111463	4.8%
S	97493	4.2%
H	91872	3.9%
Other values (13)	618068	26.4%

Lowercase Letter

Value	Count	Frequency (%)
o	78808	25.0%
l	78808	25.0%
b	39404	12.5%
t	39404	12.5%
f	39404	12.5%
a	39404	12.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2652534	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	279807	10.5%
N	272580	10.3%
I	195338	7.4%
E	193292	7.3%
C	174977	6.6%
L	167497	6.3%
T	134915	5.1%
B	111463	4.2%
S	97493	3.7%
H	91872	3.5%
Other values (19)	933300	35.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2652534	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	279807	10.5%
N	272580	10.3%
I	195338	7.4%
E	193292	7.3%
C	174977	6.6%
L	167497	6.3%
T	134915	5.1%
B	111463	4.2%
S	97493	3.7%
H	91872	3.5%
Other values (19)	933300	35.2%

playDirection
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

left	468211
right	438081

Length

Max length	5
Median length	4
Mean length	4.483377322
Min length	4

Characters and Unicode

Total characters	4063249
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	left
2nd row	left
3rd row	left
4th row	left
5th row	left

Common Values

Value	Count	Frequency (%)
left	468211	51.7%
right	438081	48.3%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
left	468211	51.7%
right	438081	48.3%

Most occurring characters

Value	Count	Frequency (%)
t	906292	22.3%
l	468211	11.5%
e	468211	11.5%
f	468211	11.5%
r	438081	10.8%
i	438081	10.8%
g	438081	10.8%
h	438081	10.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4063249	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	906292	22.3%
l	468211	11.5%
e	468211	11.5%
f	468211	11.5%
r	438081	10.8%
i	438081	10.8%
g	438081	10.8%
h	438081	10.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4063249	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	906292	22.3%
l	468211	11.5%
e	468211	11.5%
f	468211	11.5%
r	438081	10.8%
i	438081	10.8%
g	438081	10.8%
h	438081	10.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4063249	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	906292	22.3%
l	468211	11.5%
e	468211	11.5%
f	468211	11.5%
r	438081	10.8%
i	438081	10.8%
g	438081	10.8%
h	438081	10.8%

x
Real number (ℝ_≥0)

Distinct	11707
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	60.73619214

Minimum	0.58
Maximum	120.94
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	0.58
5-th percentile	21.29
Q1	40.96
median	60.8
Q3	80.36
95-th percentile	100.32
Maximum	120.94
Range	120.36
Interquartile range (IQR)	39.4

Descriptive statistics

Standard deviation	24.59857675
Coefficient of variation (CV)	0.4050068976
Kurtosis	-0.8639535791
Mean	60.73619214
Median Absolute Deviation (MAD)	19.69
Skewness	-0.009987463377
Sum	55044725.05
Variance	605.0899781
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
46.99	186	< 0.1%
65.9	174	< 0.1%
63.24	172	< 0.1%
85.36	172	< 0.1%
82.15	169	< 0.1%
47.85	168	< 0.1%
33.33	167	< 0.1%
59.7	167	< 0.1%
47.7	167	< 0.1%
48.34	166	< 0.1%
Other values (11697)	904584	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.58	1	< 0.1%
0.59	1	< 0.1%
0.63	1	< 0.1%
0.71	1	< 0.1%
0.73	1	< 0.1%
0.77	1	< 0.1%
0.78	2	< 0.1%
0.8	2	< 0.1%
0.83	1	< 0.1%
0.84	2	< 0.1%

Value	Count	Frequency (%)
120.94	1	< 0.1%
120.47	1	< 0.1%
120.01	1	< 0.1%
119.81	1	< 0.1%
119.55	1	< 0.1%
119.49	1	< 0.1%
119.39	2	< 0.1%
119.29	1	< 0.1%
119.24	1	< 0.1%
119.2	1	< 0.1%

y
Real number (ℝ)

Distinct	5422
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	26.81395279

Minimum	-1.67
Maximum	57.72
Zeros	3
Zeros (%)	< 0.1%
Negative	53
Negative (%)	< 0.1%
Memory size	6.9 MiB

Quantile statistics

Minimum	-1.67
5-th percentile	11.6
Q1	22.04
median	26.8
Q3	31.59
95-th percentile	41.86
Maximum	57.72
Range	59.39
Interquartile range (IQR)	9.55

Descriptive statistics

Standard deviation	8.354167749
Coefficient of variation (CV)	0.3115604706
Kurtosis	0.3241012869
Mean	26.81395279
Median Absolute Deviation (MAD)	4.78
Skewness	-0.009097800801
Sum	24301270.9
Variance	69.79211877
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
29.81	981	0.1%
29.82	952	0.1%
29.83	948	0.1%
23.81	942	0.1%
23.87	927	0.1%
29.74	917	0.1%
23.83	909	0.1%
29.75	909	0.1%
23.78	908	0.1%
23.85	907	0.1%
Other values (5412)	896992	99.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1.67	1	< 0.1%
-1.31	1	< 0.1%
-0.97	1	< 0.1%
-0.93	1	< 0.1%
-0.91	2	< 0.1%
-0.87	1	< 0.1%
-0.86	1	< 0.1%
-0.79	1	< 0.1%
-0.78	1	< 0.1%
-0.69	1	< 0.1%

Value	Count	Frequency (%)
57.72	1	< 0.1%
56.89	1	< 0.1%
56.07	1	< 0.1%
55.8	1	< 0.1%
55.59	1	< 0.1%
55.41	1	< 0.1%
55.31	1	< 0.1%
55.28	1	< 0.1%
55.27	1	< 0.1%
55.05	1	< 0.1%

s
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	2091
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.596570035

Minimum	0
Maximum	27.83
Zeros	60334
Zeros (%)	6.7%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.75
median	2.16
Q3	3.85
95-th percentile	6.79
Maximum	27.83
Range	27.83
Interquartile range (IQR)	3.1

Descriptive statistics

Standard deviation	2.391158449
Coefficient of variation (CV)	0.920891182
Kurtosis	13.63636117
Mean	2.596570035
Median Absolute Deviation (MAD)	1.52
Skewness	2.275058694
Sum	2353250.65
Variance	5.717638727
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	60334	6.7%
0.01	14915	1.6%
0.02	8560	0.9%
0.03	6057	0.7%
0.04	4944	0.5%
0.05	4146	0.5%
0.06	3720	0.4%
0.07	3418	0.4%
0.08	3184	0.4%
0.09	3048	0.3%
Other values (2081)	793966	87.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	60334	6.7%
0.01	14915	1.6%
0.02	8560	0.9%
0.03	6057	0.7%
0.04	4944	0.5%
0.05	4146	0.5%
0.06	3720	0.4%
0.07	3418	0.4%
0.08	3184	0.4%
0.09	3048	0.3%

Value	Count	Frequency (%)
27.83	1	< 0.1%
27.67	1	< 0.1%
27.52	1	< 0.1%
27.46	1	< 0.1%
27.42	1	< 0.1%
27.38	1	< 0.1%
27.22	2	< 0.1%
27.21	1	< 0.1%
27.05	1	< 0.1%
26.99	1	< 0.1%

a
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	1497
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.798458025

Minimum	0
Maximum	30.03
Zeros	56293
Zeros (%)	6.2%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.71
median	1.54
Q3	2.6
95-th percentile	4.49
Maximum	30.03
Range	30.03
Interquartile range (IQR)	1.89

Descriptive statistics

Standard deviation	1.447153974
Coefficient of variation (CV)	0.8046637479
Kurtosis	5.28825985
Mean	1.798458025
Median Absolute Deviation (MAD)	0.92
Skewness	1.350708611
Sum	1629928.12
Variance	2.094254626
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	56293	6.2%
0.01	11832	1.3%
0.02	6598	0.7%
0.03	5140	0.6%
0.04	4086	0.5%
0.05	3443	0.4%
0.06	2936	0.3%
0.96	2864	0.3%
1.32	2839	0.3%
1	2837	0.3%
Other values (1487)	807424	89.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	56293	6.2%
0.01	11832	1.3%
0.02	6598	0.7%
0.03	5140	0.6%
0.04	4086	0.5%
0.05	3443	0.4%
0.06	2936	0.3%
0.07	2611	0.3%
0.08	2470	0.3%
0.09	2157	0.2%

Value	Count	Frequency (%)
30.03	1	< 0.1%
26.13	1	< 0.1%
24.68	1	< 0.1%
24.61	1	< 0.1%
23.26	1	< 0.1%
22.93	1	< 0.1%
22.5	1	< 0.1%
21.55	1	< 0.1%
21.32	1	< 0.1%
21.29	1	< 0.1%

dis
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	517
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.2631815022

Minimum	0
Maximum	6.42
Zeros	60300
Zeros (%)	6.7%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.08
median	0.22
Q3	0.39
95-th percentile	0.68
Maximum	6.42
Range	6.42
Interquartile range (IQR)	0.31

Descriptive statistics

Standard deviation	0.2550544709
Coefficient of variation (CV)	0.9691200511
Kurtosis	46.29641698
Mean	0.2631815022
Median Absolute Deviation (MAD)	0.15
Skewness	4.017486438
Sum	238519.29
Variance	0.0650527831
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	60300	6.7%
0.01	48320	5.3%
0.02	26988	3.0%
0.03	21073	2.3%
0.04	18584	2.1%
0.05	17004	1.9%
0.19	16666	1.8%
0.17	16557	1.8%
0.18	16415	1.8%
0.16	16409	1.8%
Other values (507)	647976	71.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	60300	6.7%
0.01	48320	5.3%
0.02	26988	3.0%
0.03	21073	2.3%
0.04	18584	2.1%
0.05	17004	1.9%
0.06	16101	1.8%
0.07	15838	1.7%
0.08	15513	1.7%
0.09	15559	1.7%

Value	Count	Frequency (%)
6.42	1	< 0.1%
6.4	2	< 0.1%
6.38	1	< 0.1%
6.16	1	< 0.1%
6.12	1	< 0.1%
6.03	1	< 0.1%
6.01	1	< 0.1%
5.89	1	< 0.1%
5.88	1	< 0.1%
5.85	1	< 0.1%

o
Real number (ℝ_≥0)

MISSING

Distinct	36001
Distinct (%)	4.2%
Missing	39404
Missing (%)	4.3%
Infinite	0
Infinite (%)	0.0%
Mean	178.3109756

Minimum	0
Maximum	360
Zeros	7
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	0
5-th percentile	28.51
Q1	87.23
median	177.66
Q3	267.98
95-th percentile	332
Maximum	360
Range	360
Interquartile range (IQR)	180.75

Descriptive statistics

Standard deviation	100.0687965
Coefficient of variation (CV)	0.561203797
Kurtosis	-1.348592003
Mean	178.3109756
Median Absolute Deviation (MAD)	90.37
Skewness	0.01879387761
Sum	154575645
Variance	10013.76404
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
90	1259	0.1%
267.87	98	< 0.1%
271.18	93	< 0.1%
266.97	86	< 0.1%
260.04	85	< 0.1%
82.15	84	< 0.1%
269.28	83	< 0.1%
263.02	82	< 0.1%
97.87	82	< 0.1%
96.17	81	< 0.1%
Other values (35991)	864855	95.4%
(Missing)	39404	4.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7	< 0.1%
0.01	25	< 0.1%
0.02	14	< 0.1%
0.03	20	< 0.1%
0.04	15	< 0.1%
0.05	20	< 0.1%
0.06	16	< 0.1%
0.07	17	< 0.1%
0.08	19	< 0.1%
0.09	9	< 0.1%

Value	Count	Frequency (%)
360	12	< 0.1%
359.99	12	< 0.1%
359.98	13	< 0.1%
359.97	14	< 0.1%
359.96	15	< 0.1%
359.95	20	< 0.1%
359.94	9	< 0.1%
359.93	11	< 0.1%
359.92	9	< 0.1%
359.91	17	< 0.1%

dir
Real number (ℝ_≥0)

MISSING

Distinct	36001
Distinct (%)	4.2%
Missing	39404
Missing (%)	4.3%
Infinite	0
Infinite (%)	0.0%
Mean	181.2278835

Minimum	0
Maximum	360
Zeros	13
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	0
5-th percentile	23.7
Q1	91.13
median	180.76
Q3	271.31
95-th percentile	337.62
Maximum	360
Range	360
Interquartile range (IQR)	180.18

Descriptive statistics

Standard deviation	101.3668017
Coefficient of variation (CV)	0.559333364
Kurtosis	-1.283033517
Mean	181.2278835
Median Absolute Deviation (MAD)	90.09
Skewness	-0.005686777698
Sum	157104277.4
Variance	10275.22849
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
90.36	63	< 0.1%
269.15	63	< 0.1%
270.95	62	< 0.1%
93.97	61	< 0.1%
270.75	61	< 0.1%
266.68	60	< 0.1%
97.76	60	< 0.1%
88.01	60	< 0.1%
267.27	60	< 0.1%
90.37	59	< 0.1%
Other values (35991)	866279	95.6%
(Missing)	39404	4.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	13	< 0.1%
0.01	22	< 0.1%
0.02	25	< 0.1%
0.03	22	< 0.1%
0.04	21	< 0.1%
0.05	24	< 0.1%
0.06	23	< 0.1%
0.07	26	< 0.1%
0.08	18	< 0.1%
0.09	12	< 0.1%

Value	Count	Frequency (%)
360	5	< 0.1%
359.99	28	< 0.1%
359.98	16	< 0.1%
359.97	23	< 0.1%
359.96	9	< 0.1%
359.95	17	< 0.1%
359.94	18	< 0.1%
359.93	18	< 0.1%
359.92	30	< 0.1%
359.91	17	< 0.1%

event
Categorical

Distinct	22
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

None	838465
ball_snap	20999
pass_forward	18469
autoevent_ballsnap	8947
autoevent_passforward	8602
Other values (17)	10810

Length

Max length	25
Median length	4
Mean length	4.653080905
Min length	3

Characters and Unicode

Total characters	4217050
Distinct characters	25
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	None
2nd row	None
3rd row	None
4th row	None
5th row	None

Common Values

Value	Count	Frequency (%)
None	838465	92.5%
ball_snap	20999	2.3%
pass_forward	18469	2.0%
autoevent_ballsnap	8947	1.0%
autoevent_passforward	8602	0.9%
play_action	5060	0.6%
run	1265	0.1%
qb_sack	1150	0.1%
pass_arrived	851	0.1%
line_set	552	0.1%
Other values (12)	1932	0.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
none	838465	92.5%
ball_snap	20999	2.3%
pass_forward	18469	2.0%
autoevent_ballsnap	8947	1.0%
autoevent_passforward	8602	0.9%
play_action	5060	0.6%
run	1265	0.1%
qb_sack	1150	0.1%
pass_arrived	851	0.1%
line_set	552	0.1%
Other values (12)	1932	0.2%

Most occurring characters

Value	Count	Frequency (%)
n	895574	21.2%
o	890100	21.1%
e	877818	20.8%
N	838465	19.9%
a	146740	3.5%
s	89700	2.1%
_	67114	1.6%
l	65596	1.6%
p	64722	1.5%
r	58443	1.4%
Other values (15)	222778	5.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3311471	78.5%
Uppercase Letter	838465	19.9%
Connector Punctuation	67114	1.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	895574	27.0%
o	890100	26.9%
e	877818	26.5%
a	146740	4.4%
s	89700	2.7%
l	65596	2.0%
p	64722	2.0%
r	58443	1.8%
t	44252	1.3%
b	31395	0.9%
Other values (13)	147131	4.4%

Uppercase Letter

Value	Count	Frequency (%)
N	838465	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	67114	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4149936	98.4%
Common	67114	1.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	895574	21.6%
o	890100	21.4%
e	877818	21.2%
N	838465	20.2%
a	146740	3.5%
s	89700	2.2%
l	65596	1.6%
p	64722	1.6%
r	58443	1.4%
t	44252	1.1%
Other values (14)	178526	4.3%

Common

Value	Count	Frequency (%)
_	67114	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4217050	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	895574	21.2%
o	890100	21.1%
e	877818	20.8%
N	838465	19.9%
a	146740	3.5%
s	89700	2.1%
_	67114	1.6%
l	65596	1.6%
p	64722	1.5%
r	58443	1.4%
Other values (15)	222778	5.3%

Auto

The auto setting is an easily interpretable pairwise column metric of the following mapping: vartype-vartype : method, categorical-categorical : Cramer's V, numerical-categorical : Cramer's V (using a discretized numerical column), numerical-numerical : Spearman's ρ. This configuration uses the best suitable for each pair of columns.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	gameId	playId	nflId	frameId	time	jerseyNumber	team	playDirection	x	y	s	a	dis	o	dir	event
0	2021102100	56	35459.0	1	2021-10-22T00:23:17.300	22.0	DEN	left	75.42	20.77	0.97	1.03	0.09	60.75	64.69	None
1	2021102100	56	35459.0	2	2021-10-22T00:23:17.400	22.0	DEN	left	75.51	20.82	1.09	0.97	0.11	63.06	60.90	None
2	2021102100	56	35459.0	3	2021-10-22T00:23:17.500	22.0	DEN	left	75.61	20.88	1.23	0.79	0.12	63.06	61.13	None
3	2021102100	56	35459.0	4	2021-10-22T00:23:17.600	22.0	DEN	left	75.73	20.94	1.30	0.57	0.13	62.35	60.85	None
4	2021102100	56	35459.0	5	2021-10-22T00:23:17.700	22.0	DEN	left	75.84	21.01	1.33	0.37	0.13	60.65	60.99	None
5	2021102100	56	35459.0	6	2021-10-22T00:23:17.800	22.0	DEN	left	75.96	21.07	1.36	0.22	0.13	58.76	61.66	ball_snap
6	2021102100	56	35459.0	7	2021-10-22T00:23:17.900	22.0	DEN	left	76.07	21.14	1.35	0.05	0.13	57.80	60.75	None
7	2021102100	56	35459.0	8	2021-10-22T00:23:18.000	22.0	DEN	left	76.19	21.21	1.30	0.34	0.13	57.80	58.86	None
8	2021102100	56	35459.0	9	2021-10-22T00:23:18.100	22.0	DEN	left	76.29	21.28	1.29	0.48	0.13	59.17	55.39	None
9	2021102100	56	35459.0	10	2021-10-22T00:23:18.200	22.0	DEN	left	76.40	21.36	1.27	0.58	0.13	60.21	52.44	None

Last rows

	gameId	playId	nflId	frameId	time	jerseyNumber	team	playDirection	x	y	s	a	dis	o	dir	event
906282	2021102500	3998	NaN	66	2021-10-26T03:17:05.400	NaN	football	left	114.51	13.75	3.19	1.19	0.32	NaN	NaN	None
906283	2021102500	3998	NaN	67	2021-10-26T03:17:05.500	NaN	football	left	114.53	13.43	3.14	1.10	0.32	NaN	NaN	None
906284	2021102500	3998	NaN	68	2021-10-26T03:17:05.600	NaN	football	left	114.56	13.12	3.06	1.11	0.31	NaN	NaN	None
906285	2021102500	3998	NaN	69	2021-10-26T03:17:05.700	NaN	football	left	114.59	12.82	2.97	1.16	0.30	NaN	NaN	None
906286	2021102500	3998	NaN	70	2021-10-26T03:17:05.800	NaN	football	left	114.63	12.53	2.86	1.20	0.29	NaN	NaN	autoevent_passforward
906287	2021102500	3998	NaN	71	2021-10-26T03:17:05.900	NaN	football	left	112.93	14.52	22.04	0.44	2.62	NaN	NaN	pass_forward
906288	2021102500	3998	NaN	72	2021-10-26T03:17:06.000	NaN	football	left	111.34	16.07	21.95	1.40	2.22	NaN	NaN	None
906289	2021102500	3998	NaN	73	2021-10-26T03:17:06.100	NaN	football	left	109.74	17.60	21.81	2.02	2.21	NaN	NaN	None
906290	2021102500	3998	NaN	74	2021-10-26T03:17:06.200	NaN	football	left	108.17	19.12	21.66	2.39	2.19	NaN	NaN	None
906291	2021102500	3998	NaN	75	2021-10-26T03:17:06.300	NaN	football	left	106.62	20.63	21.53	2.68	2.17	NaN	NaN	None

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Dash Punctuation

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Auto

Spearman's ρ

Pearson's r

Kendall's τ

Cramér's V (φc)

Phik (φk)

Missing values

Sample

First rows

Last rows